Tabela CO_DICTCATERINGSERVICE

Definicja tabeli CO_DICTCATERINGSERVICE

Name

CO_DICTCATERINGSERVICE

Code

CO_DICTCATERINGSERVICE

Comment

 


Lista kolumn tabeli CO_DICTCATERINGSERVICE

Name

Code

CO_DICTCATERINGSERVICEID

CO_DICTCATERINGSERVICEID

NAME

NAME

PRICENETTO

PRICENETTO

VATRATE

VATRATE

ACTIVE

ACTIVE

CODE

CODE

SORT

SORT

MEALTYPEID

MEALTYPEID

CO_DICTDIETID

CO_DICTDIETID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CO_DICTCATERINGSERVICEID tabeli CO_DICTCATERINGSERVICE

Definicja kolumny CO_DICTCATERINGSERVICEID tabeli CO_DICTCATERINGSERVICE

Name

CO_DICTCATERINGSERVICEID

Code

CO_DICTCATERINGSERVICEID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NAME tabeli CO_DICTCATERINGSERVICE

Definicja kolumny NAME tabeli CO_DICTCATERINGSERVICE

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna PRICENETTO tabeli CO_DICTCATERINGSERVICE

Definicja kolumny PRICENETTO tabeli CO_DICTCATERINGSERVICE

Name

PRICENETTO

Code

PRICENETTO

Data Type

NUMBER(19,2)

Mandatory

Yes

Comment

 


Kolumna VATRATE tabeli CO_DICTCATERINGSERVICE

Definicja kolumny VATRATE tabeli CO_DICTCATERINGSERVICE

Name

VATRATE

Code

VATRATE

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ACTIVE tabeli CO_DICTCATERINGSERVICE

Definicja kolumny ACTIVE tabeli CO_DICTCATERINGSERVICE

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna CODE tabeli CO_DICTCATERINGSERVICE

Definicja kolumny CODE tabeli CO_DICTCATERINGSERVICE

Name

CODE

Code

CODE

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

 


Kolumna SORT tabeli CO_DICTCATERINGSERVICE

Definicja kolumny SORT tabeli CO_DICTCATERINGSERVICE

Name

SORT

Code

SORT

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna MEALTYPEID tabeli CO_DICTCATERINGSERVICE

Definicja kolumny MEALTYPEID tabeli CO_DICTCATERINGSERVICE

Name

MEALTYPEID

Code

MEALTYPEID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CO_DICTDIETID tabeli CO_DICTCATERINGSERVICE

Definicja kolumny CO_DICTDIETID tabeli CO_DICTCATERINGSERVICE

Name

CO_DICTDIETID

Code

CO_DICTDIETID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli CO_DICTCATERINGSERVICE

Definicja kolumny INSERTDATE tabeli CO_DICTCATERINGSERVICE

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_DICTCATERINGSERVICE

Definicja kolumny INSERTINGPERSON tabeli CO_DICTCATERINGSERVICE

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_DICTCATERINGSERVICE

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_DICTCATERINGSERVICE

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_DICTCATERINGSERVICE

Definicja kolumny LASTMODIFIEDDT tabeli CO_DICTCATERINGSERVICE

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_DICTCATERINGSERVICE

Name

Code

Primary

PK_CO_DICTCATERINGSERVICE

PK_CO_DICTCATERINGSERVICE

X


Klucz PK_CO_DICTCATERINGSERVICE tabeli CO_DICTCATERINGSERVICE

Definicja klucza PK_CO_DICTCATERINGSERVICE tabeli CO_DICTCATERINGSERVICE

Name

PK_CO_DICTCATERINGSERVICE

Code

PK_CO_DICTCATERINGSERVICE

Primary

Yes

Comment